I've been scouring the Notes help documentation and forums on the web for several days now trying to determine if Notes will look up a field to determine if it is unique. I found this code snippet in the Notes 5 forum and made a few small changes to it for my application. However, while the first part of the code works and I get an error message if the field is empty, the second part where the value is compared against existing values to determine that it is indeed unique, I never get an error. Does anyone have any insight? Many thanks!
@If(RequestNo = "";
@Failure("You have to enter a Req Number");
@IsError(
@DbLookup("":"NoCache"; "" : "" ; "All Reqs"; RequestNo; "RequestNo"));
@Success;
@IsNewDoc = 0;
@Success;
@Failure("This Req Number Already Exists."))
Here's a link to the original posting:
http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/dbe549cbd7b7921b85256a3700496de7?OpenDocument
Again, thanks for helping!
Karen
Return to top
Unique Field Lookup Issue (~John Cisgeroth... 13.Jan.04)
. . 
Print this page
